How to: Undo an AutoFilter.
Solution:
Select the 'AutoFilter' command again to undo an AutoFilter.
1) Select any cell in a list.
2) Select the 'Data' menu and select 'Filter'. (A submenu appears.)
the Filter submenu
3) Select 'AutoFilter' from the submenu. (The down arrow buttons disappear and all records are displayed in the list.)